SELECT Id FROM new_searchtable
where
(town = 'Cornish' and state='NH'
or town = 'Eastman' and state='NH'
or town = 'Enfield' and state='NH'
or town = 'Hanover' and state='NH'
or town = 'Lebanon' and state='NH'
or town = 'Lyme' and state='NH'
or town = 'Plainfield' and state='NH'
)
and (type = 'R' or type ='O')
AND list_price BETWEEN '500000' AND '1000000'
ORDER BY list_price Desc
Upper Valley Area NH Homes page 30
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:In Town Corner Lot, sits this 4 bedroom, 2 bath Cape style home with sidewalks to Dartmouth and Main Street. The first floor has open floor plan with large living room, dinning area, 2 bedrooms and full bath. The second floor has an additional 2 bedrooms and nicely updated 3/4 bathroom and possible office space. A solid home in a great location would make a great investment or a primary residence.
Description:Located on scenic Blueberry Hill Drive with the beautiful Killington Mountain range as its backdrop, this spectacular white brick home offers lovely views from nearly every room in the home. Offering over 2,360 square feet of above-grade living space plus more than 1,500 finished square feet below grade, this spacious four-bedroom, three-bath residence provides exceptional room for both everyday living and entertaining. The dramatic living room features large windows, a striking brick fireplace, and direct access to a large Trex deck where the view takes center stage. Adjacent to the dining room, a charming glass sitting room creates the perfect place to relax and enjoy the ever-changing mountain scenery. The thoughtfully designed kitchen overlooks beautiful gardens and a stone patio and features cherry cabinetry, Corian countertops, and a comfortable eat-in counter area. Downstairs, the expansive Great Room offers a second impressive stone fireplace, bar, and wet bar, creating an ideal space for gatherings. A bright and inviting office or studio provides flexibility for remote work, hobbies, or creative pursuits. All four generously sized bedrooms are conveniently located on the same level. The primary suite enjoys its own private bath, while three additional bedrooms share a full bathroom. Practical amenities include a two-car garage and an oversized tiled mudroom with entrances from both the driveway and garage. A laundry area and additional bathroom complete this functional space. Set on 2.47 private acres, with opportunity to purchase an additional 2.16 acre parcel located directly below this home on Blueberry Hill Drive. Ideally situated 3.5 miles from the Lebanon Green, five miles from Dartmouth Hitchcock Medical Center and less than six miles from Dartmouth College this home has a wonderful location! Agent has personal interest in this property. Home is vacant and has been digitally staged in photos.
Description:The sun streams in to this delightfully bright home set on a gorgeous 3.45 ac site in Lebanon. Spacious great room with beautiful outlook. 2648 sq ft home is currently set up as 1 bedroom, 2.5 bath, with large first floor master suite. Upstairs has a large family/game room and a full bath. Seller will give credit of builder's estimate to add two more bedrooms to the second floor. (House has a 4 bedroom septic system). Full basement provides great space for workshop or more finished space. 2 car garage. Open house Sunday, May 31 from 1--3pm.
Description:Nestled on 3 private acres in Etna, NH this inviting 4-bedroom, 3-bathroom home offers picturesques water views and a peaceful New Hampshire lifestyle just minutes from Hanover. The landscaped grounds feature mature plantings, open lawn areas, and woodland surroundings that enhance the property’s privacy and charm. Start your mornings on the southeast-facing deck with a cup of coffee while listening to loons call across the water, and enjoy cozy winter days warmed by the pellet stove. Inside, you’ll find a thoughtful blend of comfort and character, including a handsome wood-paneled library, cherry kitchen cabinetry, an indoor sauna, and a newer Jacuzzi soaking tub—perfect for relaxing after a long day. The property provides both privacy and natural beauty with easy acess to Dartmouth College, Dartmouth Health, and all the amenities Hanover, NH has to offer.
Description:"The Rock Ridge Community" Built in 2020 this Colonial style home offers 4 bedroom, 3.5 bath home with extra finished living space in the full walkup basement. Open concept living with hardwood floors, granite counter tops, tiled baths and flexible floor plan. Along with ungraded finishes when purchased owners have landscaped the property with full fencing surround the lot, added a 3 season sunroom off the kitchen plus added over 700 square feet of living space with a finished basement with full bath. Share the community garden, enjoy socials at the Farmhouse, and the privileges that an HOA provides. Close to I89, DHMC, Dartmouth College, Lebanon 6 Movie Theater, Downtown and plenty of shopping. Open House Saturday July 11th 10-12
Description:This West Lebanon gem combines classic comfort with a versatile, modern layout. At the heart of the home, a bright eat-in kitchen with a large island flows naturally into a spacious living room anchored by a cozy fireplace. The second floor offers four bedrooms, including a primary suite with a private bath. For added flexibility, a separate suite above the two-car garage features a kitchenette and built-ins—perfect for guests, a home office, or recreation. Outside, enjoy the quiet neighborhood from the deck or the level, tree-lined backyard. Ideally located, you’re just a quick bike ride from Hanover’s Main Street with easy Advance Transit access to the rest of the Upper Valley. Showings to begin at the Open House on Sunday, March 29th from 1pm to 3pm.
Description:A property for all seasons with waterfront, views, color, comfort and privacy. From the moment you walk into this totally renovated, architecturally designed waterfront home, you will be taken! The floor plan takes advantage of light, efficiency, space and views; includes kitchen, with island crafted of hardwood maple salvaged from a bowling alley in Maine and beautifully refurbished, high-end appliances, dining area, living room and the bedroom where you awaken looking at the River. In addition, there is a laundry area and three-quarter bathroom and a sleeping loft as well as a small area of basement. Not only River frontage but a cove, too, a dock and docking ramps and a Level 2 EV Charger. The owners have been the ultimate stewards of this property; they have had engineers assess the banks and have added structural components not only to better stabilize the banks but to also assure the integrity of the structure of the house. A gem and only minutes to “in town” Hanover!! *‘Renovations were completed in 2022, with design by Daniel Johnson of Watershed Studio Architecture."
Description:Beach Access! Step into timeless elegance with this extraordinary 1929 Classical Revival home, where historic craftsmanship and gracious living come together beautifully. Period details include ornate plaster moldings, stained and beveled glass windows, quarter-sawn oak floors, rich mahogany doors, extra-high ceilings, a sweeping front staircase, and a classic fireplace that creates a warm, dramatic sense of arrival. Offering nearly 5,000 square feet, the home features five bedrooms and six baths, including four ensuite bedrooms for comfort and privacy. Two expansive porches, including a screened porch, overlook spectacular perennial gardens filled with layered plantings, seasonal blooms, and mature landscaping that provide color and fragrance from spring through fall. Pollinator-friendly varieties attract birds and butterflies, while established borders and intimate garden spaces create a serene, park-like setting ideal for morning coffee, sunset gatherings, and evening stargazing. A charming portico and garage add convenience while preserving architectural character. Ideally located in Historic Shaker Village minutes from Dartmouth College and Dartmouth Health, the property offers rare flexibility. Formerly a successful bed and breakfast and now a single-family residence, it is well suited for elegant private living or renewed hospitality use. Enjoy year-round recreation with nearby lake activities, rail trails, and mountain biking, plus easy access to multiple ski areas including Whaleback, Sunapee, Dartmouth Skiway, and Ragged Mountain, with Killington, Stowe, and Loon about an hour away. Completing this remarkable offering is a peaceful, private meditation chapel — a truly unique retreat space that sets this home apart.
Description:Set on 11.5 private acres in scenic Plainfield, New Hampshire, this beautifully designed 2021 home offers the perfect balance of comfort, privacy, and modern living. The main living area is warm and welcoming, centered around a striking stone hearth with a propane fireplace. The bright kitchen opens seamlessly to the living and dining areas, creating an easy flow for everyday living and entertaining. An oversized 2-car garage offers direct entry into the home, while a dedicated laundry room and half bath are conveniently tucked just off the kitchen. A spacious wraparound deck expands the living space outdoors, providing a peaceful setting for summer dining, relaxing, and enjoying the surrounding landscape and water views. The primary suite features a beautifully appointed en suite bath and walk-in closet. The finished lower level offers a large sauna, flexible space for a gym, office, media room, or additional living area. A whole-house generator adds year-round peace of mind. Surrounded by nature yet conveniently located with easy access to Hanover, Lebanon, Shopping, Dartmouth College, and Dartmouth Hitchcock Medical Center, this property offers a wonderful blend of privacy, convenience, and Upper Valley living.